FO_Hub_Job_Def_Detail
This table contains the specific Client/Provider/PtLocations to be included on job run when selecting data from tables to use for this job.
Field | Type | Notes |
---|---|---|
Hub_Job_Def_Detail_ID |
int |
ID field, a counter. Unique |
HubCode |
varchar(50) |
Code for HUB |
JobID |
varchar(50) |
Enter a unique ID for job. Recommended to establish a naming convention as this will assist in readily identifying jobs. |
ClientCode |
varchar(50) |
Defines a list of client codes. Multidimensional pipe delimited field, with leading and trailing pipes. Enter valid client codes separated by pipes. |
ProviderCode |
varchar(50) |
Defines a list of provider codes. Multidimensional pipe delimited field, with leading and trailing pipes. Enter valid provider codes separated by pipes. |
PtLocationCode |
varchar(50) |
Defines a list of PTLoc, patient location, codes. Multidimensional pipe delimited field, with leading and trailing pipes. Enter valid PTLoc codes separated by pipes. |
CreateDate |
datetime |
Date record was created. Informational |
EditDate |
datetime |
Date record was last edited. Informational |
CreateUser |
varchar(50) |
User who created record. Informational |
EditUser |
varchar(50) |
User who last edited record. Informational |